Hệ thống Quản lý ngành Sữa trong C#

8.397 lượt xem;
1 <?xml version="1.0" encoding="utf-8"?>
2 <xs:schema id="milkdairyDataSet2" targetNamespace="http://tempuri.org/milkdairyDataSet2.xsd" xmlns:mstns="http://tempuri.org/milkdairyDataSet2.xsd" xmlns="http://tempuri.org/milkdairyDataSet2.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
3   <xs:annotation>
4     <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
5       <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
6         <Connections>
7           <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="milkdairyConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="milkdairyConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.MilkDairyManagementSystemCSharp.Properties.Settings.GlobalReference.Default.milkdairyConnectionString" Provider="System.Data.SqlClient" />
8         </Connections>
9         <Tables>
10           <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="acntTableAdapter" GeneratorDataComponentClassName="acntTableAdapter" Name="acnt" UserDataComponentName="acntTableAdapter">
11             <MainSource>
12               <DbSource ConnectionRef="milkdairyConnectionString (Settings)" DbObjectName="dbo.acnt" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
13                 <DeleteCommand>
14                   <DbCommand CommandType="Text" ModifiedByUser="false">
15                     <CommandText>DELETE FROM [dbo].[acnt] WHERE (([Id] = @Original_Id) AND ((@IsNull_name = 1 AND [name] IS NULL) OR ([name] = @Original_name)) AND ((@IsNull_addr = 1 AND [addr] IS NULL) OR ([addr] = @Original_addr)) AND ((@IsNull_mobile = 1 AND [mobile] IS NULL) OR ([mobile] = @Original_mobile)) AND ((@IsNull_center = 1 AND [center] IS NULL) OR ([center] = @Original_center)))</CommandText>
16                     <Parameters>
17                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
18                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="true" SourceVersion="Original" />
19                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
20                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_addr" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="addr" SourceColumnNullMapping="true" SourceVersion="Original" />
21                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_addr" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="addr" SourceColumnNullMapping="false" SourceVersion="Original" />
22                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_mobile" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mobile" SourceColumnNullMapping="true" SourceVersion="Original" />
23                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_mobile" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mobile" SourceColumnNullMapping="false" SourceVersion="Original" />
24                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_center" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="center" SourceColumnNullMapping="true" SourceVersion="Original" />
25                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_center" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="center" SourceColumnNullMapping="false" SourceVersion="Original" />
26                     </Parameters>
27                   </DbCommand>
28                 </DeleteCommand>
29                 <InsertCommand>
30                   <DbCommand CommandType="Text" ModifiedByUser="false">
31                     <CommandText>INSERT INTO [dbo].[acnt] ([name], [addr], [mobile], [center]) VALUES (@name, @addr, @mobile, @center);
32 SELECT Id, name, addr, mobile, center FROM acnt WHERE (Id = SCOPE_IDENTITY())</CommandText>
33                     <Parameters>
34                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
35                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@addr" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="addr" SourceColumnNullMapping="false" SourceVersion="Current" />
36                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@mobile" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mobile" SourceColumnNullMapping="false" SourceVersion="Current" />
37                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@center" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="center" SourceColumnNullMapping="false" SourceVersion="Current" />
38                     </Parameters>
39                   </DbCommand>
40                 </InsertCommand>
41                 <SelectCommand>
42                   <DbCommand CommandType="Text" ModifiedByUser="false">
43                     <CommandText>SELECT Id, name, addr, mobile, center FROM dbo.acnt</CommandText>
44                     <Parameters />
45                   </DbCommand>
46                 </SelectCommand>
47                 <UpdateCommand>
48                   <DbCommand CommandType="Text" ModifiedByUser="false">
49                     <CommandText>UPDATE [dbo].[acnt] SET [name] = @name, [addr] = @addr, [mobile] = @mobile, [center] = @center WHERE (([Id] = @Original_Id) AND ((@IsNull_name = 1 AND [name] IS NULL) OR ([name] = @Original_name)) AND ((@IsNull_addr = 1 AND [addr] IS NULL) OR ([addr] = @Original_addr)) AND ((@IsNull_mobile = 1 AND [mobile] IS NULL) OR ([mobile] = @Original_mobile)) AND ((@IsNull_center = 1 AND [center] IS NULL) OR ([center] = @Original_center)));
50 SELECT Id, name, addr, mobile, center FROM acnt WHERE (Id = @Id)</CommandText>
51                     <Parameters>
52                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
53                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@addr" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="addr" SourceColumnNullMapping="false" SourceVersion="Current" />
54                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@mobile" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mobile" SourceColumnNullMapping="false" SourceVersion="Current" />
55                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@center" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="center" SourceColumnNullMapping="false" SourceVersion="Current" />
56                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
57                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="true" SourceVersion="Original" />
58                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
59                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_addr" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="addr" SourceColumnNullMapping="true" SourceVersion="Original" />
60                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_addr" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="addr" SourceColumnNullMapping="false" SourceVersion="Original" />
61                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_mobile" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mobile" SourceColumnNullMapping="true" SourceVersion="Original" />
62                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_mobile" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mobile" SourceColumnNullMapping="false" SourceVersion="Original" />
63                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_center" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="center" SourceColumnNullMapping="true" SourceVersion="Original" />
64                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_center" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="center" SourceColumnNullMapping="false" SourceVersion="Original" />
65                       <Parameter AllowDbNull="false" AutogeneratedName="Id" ColumnName="Id" DataSourceName="[7B85E66E5B47A16D9E4F6DAC01C44393_DIO 2015\PROJECTS\MILKDAIRYMANAGEMENTSYSTEMCSHARP\MILKDAIRYMANAGEMENTSYSTEMCSHARP\MILKDAIRY.MDF].dbo.acnt" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Current" />
66                     </Parameters>
67                   </DbCommand>
68                 </UpdateCommand>
69               </DbSource>
70             </MainSource>
71             <Mappings>
72               <Mapping SourceColumn="Id" DataSetColumn="Id" />
73               <Mapping SourceColumn="name" DataSetColumn="name" />
74               <Mapping SourceColumn="addr" DataSetColumn="addr" />
75               <Mapping SourceColumn="mobile" DataSetColumn="mobile" />
76               <Mapping SourceColumn="center" DataSetColumn="center" />
77             </Mappings>
78             <Sources />
79           </TableAdapter>
80         </Tables>
81         <Sources />
82       </DataSource>
83     </xs:appinfo>
84   </xs:annotation>
85   <xs:element name="milkdairyDataSet2" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="milkdairyDataSet2" msprop:Generator_UserDSName="milkdairyDataSet2">
86     <xs:complexType>
87       <xs:choice minOccurs="0" maxOccurs="unbounded">
88         <xs:element name="acnt" msprop:Generator_TableClassName="acntDataTable" msprop:Generator_TableVarName="tableacnt" msprop:Generator_TablePropName="acnt" msprop:Generator_RowDeletingName="acntRowDeleting" msprop:Generator_RowChangingName="acntRowChanging" msprop:Generator_RowEvHandlerName="acntRowChangeEventHandler" msprop:Generator_RowDeletedName="acntRowDeleted" msprop:Generator_UserTableName="acnt" msprop:Generator_RowChangedName="acntRowChanged" msprop:Generator_RowEvArgName="acntRowChangeEvent" msprop:Generator_RowClassName="acntRow">
89           <xs:complexType>
90             <xs:sequence>
91               <xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" msprop:Generator_UserColumnName="Id" type="xs:int" />
92               <xs:element name="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" msprop:Generator_UserColumnName="name" minOccurs="0">
93                 <xs:simpleType>
94                   <xs:restriction base="xs:string">
95                     <xs:maxLength value="50" />
96                   </xs:restriction>
97                 </xs:simpleType>
98               </xs:element>
99               <xs:element name="addr" msprop:Generator_ColumnVarNameInTable="columnaddr" msprop:Generator_ColumnPropNameInRow="addr" msprop:Generator_ColumnPropNameInTable="addrColumn" msprop:Generator_UserColumnName="addr" minOccurs="0">
100                 <xs:simpleType>
101                   <xs:restriction base="xs:string">
102                     <xs:maxLength value="50" />
103                   </xs:restriction>
104                 </xs:simpleType>
105               </xs:element>
106               <xs:element name="mobile" msprop:Generator_ColumnVarNameInTable="columnmobile" msprop:Generator_ColumnPropNameInRow="mobile" msprop:Generator_ColumnPropNameInTable="mobileColumn" msprop:Generator_UserColumnName="mobile" minOccurs="0">
107                 <xs:simpleType>
108                   <xs:restriction base="xs:string">
109                     <xs:maxLength value="50" />
110                   </xs:restriction>
111                 </xs:simpleType>
112               </xs:element>
113               <xs:element name="center" msprop:Generator_ColumnVarNameInTable="columncenter" msprop:Generator_ColumnPropNameInRow="center" msprop:Generator_ColumnPropNameInTable="centerColumn" msprop:Generator_UserColumnName="center" minOccurs="0">
114                 <xs:simpleType>
115                   <xs:restriction base="xs:string">
116                     <xs:maxLength value="50" />
117                   </xs:restriction>
118                 </xs:simpleType>
119               </xs:element>
120             </xs:sequence>
121           </xs:complexType>
122         </xs:element>
123       </xs:choice>
124     </xs:complexType>
125     <xs:unique name="Constraint1" msdata:PrimaryKey="true">
126       <xs:selector xpath=".//mstns:acnt" />
127       <xs:field xpath="mstns:Id" />
128     </xs:unique>
129   </xs:element>
130 </xs:schema>


Web, Tìm kết quả nhanh

Kích thước hoặc độ phức tạp của bản gửi này, tác giả đã gửi nó dưới dạng tệp .zip để rút ngắn thời gian tải xuống của bạn. Sau khi tải xuống, bạn sẽ cần một chương trình như Winzip để giải nén nó.

Tất cả các tệp đều được codefly.vn quét mỗi ngày một lần để tìm vi-rút, nhưng vi-rút mới xuất hiện hàng ngày nên không có chương trình phòng ngừa nào có thể bắt được 100% chúng.

ĐỂ AN TOÀN CỦA CHÍNH BẠN, VUI LÒNG:

1. Quét lại các tệp đã tải xuống bằng trình kiểm tra vi-rút cá nhân của bạn trước khi sử dụng.

2. KHÔNG BAO GIỜ, chạy các tệp đã biên dịch (.exe's, .ocx's, .dll's, v.v.)--chỉ chạy code mà bạn đã xem ít nhất 1 lần.

Official Website:

https://www.kashipara.com/.....y-management-system

Gõ tìm kiếm nhanh...



Dự án liên quan!

Cách tạo đồng hồ bấm giờ trong C#

70 lượt xem

Hệ thống quản lý hàng tồn kho sử dụng cơ sở dữ liệu VB.NET và MySQL với mã nguồn

69 lượt xem

Đếm nguyên âm và phụ âm

115 lượt xem

Phần mềm quản lý nhân viên hiện đại sử dụng C#.net và Bunifu Framework với Full Source Code (2020)

176 lượt xem

Hệ thống quản lý đại học bằng C# với mã nguồn đầy đủ

140 lượt xem

Hệ thống quản lý bệnh viện bằng C# với mã nguồn đầy đủ

157 lượt xem